from sqlalchemy import Column,Integer,String,DateTime,ForeignKey
from dbCon import DB_URI
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from datetime import datetime
from sqlalchemy.orm import relationship

engine = create_engine(DB_URI,echo=True)

Base = declarative_base(engine)
class Users(Base):
    __tablename__ = 'users'
    user_name=Column(String(10),primary_key=True)
    password=Column(String(16))
    user_targetcity=Column(String(20))
    user_targetjob=Column(String(20))
    user_minsalary=Column(String(10))
    user_maxsalary=Column(String(10))

class Job1(Base):
    __tablename__ = 'job1'
    job_id=Column(String(255),primary_key=True)
    job_name = Column(String(255))
    salary_min = Column(String(255))
    salary_max = Column(String(255))
    salary_sys = Column(String(255))
    place = Column(String(255))
    experience = Column(String(255))
    education = Column(String(255))
    company_name = Column(String(255))
    company_type = Column(String(255))